Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Identify SQL requirements from the specification documentation
   • Determine the information to be used from the database
   • Identify the tables that hold this information
   • Identify the primary keys in these tables
   • Identify the relationships between these tables, including foreign keys
2. Create a relational database
   • Create tables in a database, using SQL statements
   • Identify the primary and foreign keys for database table
   • Manipulate the data in a database, using SQL statements
   • Query the database, using SQL statements
   • Write SQL statements to retrieve information from the database
3. Test SQL results
   • Construct test data to test SQL statements
   • Determine the expected results in order to verify SQL statements
   • Verify the result of the constructed SQL statements, against the expected results

Performance Evidence

Evidence of the ability to:

identify structured query language (SQL) requirements

create the databases and tables

generate queries for one or more tables, to provide the required data

add, modify and delete records from the database tables

test and verify SQL statements.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

---

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

explain the features and application of the following aggregate functions:

MIN

MAX

SUM

AVG

COUNT

COUNT(*)

explain the features and application of the following clause functions:

GROUP BY

HAVING

ORDER BY

dates and times

SQL data types

numbers

text

SQL syntax:

SELECT

FROM

WHERE

LIKE

DISTINCT

CREATE

ALTER TABLE

INSERT INTO

UPDATE

DELETE

DROP

describe the principles of "combining and/or condition" in SQL statements and Boolean operators:

IN and BETWEEN conditional operators

mathematical operators

table joins (relationships).

---